<?php
	/*  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *
	 *
	 *	WhyWDB (World of Warcraft cache parser.)
	 *	Copyright (C) 2009, Brent Flap <blog.cyberdevil.nl>
	 *
	 *	This file is part of WhyWDB.
	 *
	 *	WhyWDB is free software: you can redistribute it and/or modify
	 *	it under the terms of the GNU General Public License as published by
	 *	the Free Software Foundation, either version 3 of the License, or
	 *	any later version.
	 *
	 *	WhyWDB is distributed in the hope that it will be useful,
	 *	but WITHOUT ANY WARRANTY; without even the implied warranty of
	 *	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
	 *	GNU General Public License for more details.
	 *
	 *	You should have received a copy of the GNU General Public License
	 *	along with WhyWDB.  If not, see <http://www.gnu.org/licenses/>.
	 *
	 *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  *  */
	$sql_structs = array(
		// ArcEmu structure
		"BDIW"	=> array(
			"BDIW"							=> "items",
			"class"							=> "classid",
			"subclass"						=> "subclass",
			"field4"						=> "depClassId",
			"name1"							=> "nameval",
			"displayid"						=> "displayid",
			"quality"						=> "qualId",
			"flags"							=> "typeBin",
			"buyprice"						=> "buyPriceAmt",
			"sellprice"						=> "sellPriceAmt",
			"inventorytype"					=> "equipSlotId",
			"allowableclass"				=> "classesBin",
			"allowablerace"					=> "racesBin",
			"itemlevel"						=> "itemLvl",
			"requiredlevel"					=> "reqLvl",
			"RequiredSkill"					=> "reqSkillId",
			"RequiredSkillRank"				=> "reqSkillLvl",
			"RequiredSpell"					=> "reqSpellId",
			"RequiredPlayerRank1"			=> "reqRankId",
			"RequiredPlayerRank2"			=> "reqSuperRankId",
			"RequiredFaction"				=> "reqFactionId",
			"RequiredFactionStanding"		=> "reqFactionLvl",
			"Unique"						=> "stackUniqueMaxAmt",
			"maxcount"						=> "stackMaxAmt",
			"ContainerSlots"				=> "containerSlots",
			"itemstatscount"				=> "itemStatsCount",
			"stat_type1"					=> "stat1Id",
			"stat_value1"					=> "stat1Amt",
			"stat_type2"					=> "stat2Id",
			"stat_value2"					=> "stat2Amt",
			"stat_type3"					=> "stat3Id",
			"stat_value3"					=> "stat3Amt",
			"stat_type4"					=> "stat4Id",
			"stat_value4"					=> "stat4Amt",
			"stat_type5"					=> "stat5Id",
			"stat_value5"					=> "stat5Amt",
			"stat_type6"					=> "stat6Id",
			"stat_value6"					=> "stat6Amt",
			"stat_type7"					=> "stat7Id",
			"stat_value7"					=> "stat7Amt",
			"stat_type8"					=> "stat8Id",
			"stat_value8"					=> "stat8Amt",
			"stat_type9"					=> "stat9Id",
			"stat_value9"					=> "stat9Amt",
			"stat_type10"					=> "stat10Id",
			"stat_value10"					=> "stat10Amt",
			"ScaledStatsDistributionId"		=> "ScalingStatDistribution",
			"ScaledStatsDistributionFlags"	=> "ScalingStatValue",
			"dmg_min1"						=> "dmg1MinAmt",
			"dmg_max1"						=> "dmg1MaxAmt",
			"dmg_type1"						=> "dmg1TypeId",
			"dmg_min2"						=> "dmg2MinAmt",
			"dmg_max2"						=> "dmg2MaxAmt",
			"dmg_type2"						=> "dmg2TypeId",
			"armor"							=> "resistPhysAmt",
			"holy_res"						=> "resistHolyAmt",
			"fire_res"						=> "resistFireAmt",
			"nature_res"					=> "resistNatureAmt",
			"frost_res"						=> "resistFrostAmt",
			"shadow_res"					=> "resistShadowAmt",
			"arcane_res"					=> "resistArcaneAmt",
			"delay"							=> "wpnDelayAmt",
			"ammo_type"						=> "ammoTypeId",
			"range"							=> "rangeMaxFlt",
			"spellid_1"						=> "spell1Id",
			"spelltrigger_1"				=> "spell1TriggerId",
			"spellcharges_1"				=> "spell1ChargeAmt",
			"spellcooldown_1"				=> "spell1CooldownAmt",
			"spellcategory_1"				=> "spell1CategoryId",
			"spellcategorycooldown_1"		=> "spell1CategoryCooldownAmt",
			"spelltrigger_2"				=> "spell2TriggerId",
			"spellcharges_2"				=> "spell2ChargeAmt",
			"spellcooldown_2"				=> "spell2CooldownAmt",
			"spellcategory_2"				=> "spell2CategoryId",
			"spellcategorycooldown_2"		=> "spell2CategoryCooldownAmt",
			"spelltrigger_3"				=> "spell3TriggerId",
			"spellcharges_3"				=> "spell3ChargeAmt",
			"spellcooldown_3"				=> "spell3CooldownAmt",
			"spellcategory_3"				=> "spell3CategoryId",
			"spellcategorycooldown_3"		=> "spell3CategoryCooldownAmt",
			"spelltrigger_4"				=> "spell4TriggerId",
			"spellcharges_4"				=> "spell4ChargeAmt",
			"spellcooldown_4"				=> "spell4CooldownAmt",
			"spellcategory_4"				=> "spell4CategoryId",
			"spellcategorycooldown_4"		=> "spell4CategoryCooldownAmt",
			"spelltrigger_5"				=> "spell5TriggerId",
			"spellcharges_5"				=> "spell5ChargeAmt",
			"spellcooldown_5"				=> "spell5CooldownAmt",
			"spellcategory_5"				=> "spell5CategoryId",
			"spellcategorycooldown_5"		=> "spell5CategoryCooldownAmt",
			"bonding"						=> "bondId",
			"description"					=> "descrVal",
			"page_id"						=> "bookTextId",
			"page_language"					=> "bookLngId",
			"page_material"					=> "bookStationaryId",
			"quest_id"						=> "startQuestId",
			"lock_id"						=> "lockPickMinLvl",
			"lock_material"					=> "materialId",
			"sheathID"						=> "sheathId",
			"randomprop"					=> "randProperty1Id",
			"randomsuffix"					=> "randProperty2Id",
			"block"							=> "blockAmt",
			"itemset"						=> "itemSetId",
			"MaxDurability"					=> "duraMaxAmt",
			"ZoneNameID"					=> "itemAreaId",
			"mapid"							=> "itemMapId",
			"bagfamily"						=> "bagFamilyId",
			"TotemCategory"					=> "totemCatDbcId",
			"socket_color_1"				=> "socket1ColorId",
			"unk201_3"						=> "socket1Amt",
			"socket_color_2"				=> "socket2ColorId",
			"unk201_5"						=> "socket2Amt",
			"socket_color_3"				=> "socket3ColorId",
			"unk201_7"						=> "socket3Amt",
			"socket_bonus"					=> "socketBonus",
			"GemProperties"					=> "gemPropertiesDbcId",
			"ReqDisenchantSkill"			=> "disenchantMinLvl",
			"ArmorDamageModifier"			=> "armorDmgModFlt",
			"ExistingDuration"				=> "ExistingDuration",
			"ItemLimitCategoryId"			=> "ItemLimitCategory",
			"HolidayId"						=> "HolidayId",
		),
		"TSQW"	=> array(
			"TSQW"							=> "quests",
			"ZoneId"						=> "areaIdOrsortId",
			"Sort"							=> "areaIdOrsortId",
			"flags"							=> "",
			"MinLevel"						=> "",
			"questlevel"					=> "QuestLevel",
			"Type"							=> "QuestType",
			"RequiredRaces"					=> "",
			"RequiredClass"					=> "",
			"RequiredTradeskill"			=> "",
			"RequiredTradeskillValue"		=> "",
			"RequiredRepFaction"			=> "FactionId",
			"RequiredRepValue"				=> "FactionAmt",
			"LimitTime"						=> "",
			"SpecialFlags"					=> "",
			"PrevQuestId"					=> "",
			"NextQuestId"					=> "nextQuestId",
			"srcItem"						=> "",
			"SrcItemCount"					=> "",
			"Title"							=> "",
			"Details"						=> "",
			"Objectives"					=> "",
			"CompletionText"				=> "",
			"IncompleteText"				=> "",
			"EndText"						=> "",
			"ObjectiveText1"				=> "",
			"ObjectiveText2"				=> "",
			"ObjectiveText3"				=> "",
			"ObjectiveText4"				=> "",
			"ReqItemId1"					=> "",
			"ReqItemId2"					=> "",
			"ReqItemId3"					=> "",
			"ReqItemId4"					=> "",
			"ReqItemId5"					=> "",
			"ReqItemId6"					=> "",
			"ReqItemCount1"					=> "",
			"ReqItemCount2"					=> "",
			"ReqItemCount3"					=> "",
			"ReqItemCount4"					=> "",
			"ReqItemCount5"					=> "",
			"ReqItemCount6"					=> "",
			"ReqKillMobOrGOId1"				=> "",
			"ReqKillMobOrGOId2"				=> "",
			"ReqKillMobOrGOId3"				=> "",
			"ReqKillMobOrGOId4"				=> "",
			"ReqKillMobOrGOCount1"			=> "",
			"ReqKillMobOrGOCount2"			=> "",
			"ReqKillMobOrGOCount3"			=> "",
			"ReqKillMobOrGOCount4"			=> "",
			"ReqCastSpellId1"				=> "",
			"ReqCastSpellId2"				=> "",
			"ReqCastSpellId3"				=> "",
			"ReqCastSpellId4"				=> "",
			"ReqEmoteId1"					=> "",
			"ReqEmoteId2"					=> "",
			"ReqEmoteId3"					=> "",
			"ReqEmoteId4"					=> "",
			"RewChoiceItemId1"				=> "",
			"RewChoiceItemId2"				=> "",
			"RewChoiceItemId3"				=> "",
			"RewChoiceItemId4"				=> "",
			"RewChoiceItemId5"				=> "",
			"RewChoiceItemId6"				=> "",
			"RewChoiceItemCount1"			=> "",
			"RewChoiceItemCount2"			=> "",
			"RewChoiceItemCount3"			=> "",
			"RewChoiceItemCount4"			=> "",
			"RewChoiceItemCount5"			=> "",
			"RewChoiceItemCount6"			=> "",
			"RewItemId1"					=> "",
			"RewItemId2"					=> "",
			"RewItemId3"					=> "",
			"RewItemId4"					=> "",
			"RewItemCount1"					=> "",
			"RewItemCount2"					=> "",
			"RewItemCount3"					=> "",
			"RewItemCount4"					=> "",
			"RewRepFaction1"				=> "",
			"RewRepFaction2"				=> "",
			"RewRepFaction3"				=> "",
			"RewRepFaction4"				=> "",
			"RewRepFaction5"				=> "",
			"RewRepFaction6"				=> "",
			"RewRepValue1"					=> "",
			"RewRepValue2"					=> "",
			"RewRepValue3"					=> "",
			"RewRepValue4"					=> "",
			"RewRepValue5"					=> "",
			"RewRepValue6"					=> "",
			"RewRepLimit"					=> "",
			"RewMoney"						=> "RewMoney",
			"RewXP"							=> "",
			"RewSpell"						=> "",
			"CastSpell"						=> "",
			"PointMapId"					=> "",
			"PointX"						=> "",
			"PointY"						=> "",
			"PointOpt"						=> "",
			"RewardMoneyAtMaxLevel"			=> "SubExp80",
			"ExploreTrigger1"				=> "",
			"ExploreTrigger2"				=> "",
			"ExploreTrigger3"				=> "",
			"ExploreTrigger4"				=> "",
			"RequiredOneOfQuest"			=> "",
			"RequiredQuest1"				=> "",
			"RequiredQuest2"				=> "",
			"RequiredQuest3"				=> "",
			"RequiredQuest4"				=> "",
			"RemoveQuests"					=> "",
			"ReceiveItemId1"				=> "",
			"ReceiveItemId2"				=> "",
			"ReceiveItemId3"				=> "",
			"ReceiveItemId4"				=> "",
			"ReceiveItemCount1"				=> "",
			"ReceiveItemCount2"				=> "",
			"ReceiveItemCount3"				=> "",
			"ReceiveItemCount4"				=> "",
			"IsRepeatable"					=> "",
			"bonushonor"					=> "",
			"rewardtitleid"					=> "",
			"rewardtalents"					=> "",
			"suggestedplayers"				=> "",
			"detailemotecount"				=> "",
			"detailemote1"					=> "",
			"detailemote2"					=> "",
			"detailemote3"					=> "",
			"detailemote4"					=> "",
			"detailemotedelay1"				=> "",
			"detailemotedelay2"				=> "",
			"detailemotedelay3"				=> "",
			"detailemotedelay4"				=> "",
			"completionemotecnt"			=> "",
			"completionemote1"				=> "",
			"completionemote2"				=> "",
			"completionemote3"				=> "",
			"completionemote4"				=> "",
			"completionemotedelay1"			=> "",
			"completionemotedelay2"			=> "",
			"completionemotedelay3"			=> "",
			"completionemotedelay4"			=> "",
			"completeemote"					=> "",
			"incompleteemote"				=> "",
			"iscompletedbyspelleffect"		=> "",
		),
		"BOMW" => array(
			"BOMW"							=> "creature_template",
			"name"							=> "name1",
			"subname"						=> "subname",
			"Iconname"						=> "iconname",
			"npcflag"						=> "type_flags",
			"type"							=> "typeid",
			"family"						=> "family_id",
			"rank"							=> "rank",
			"killcredit1"					=> "killcredit1",
			"killcredit2"					=> "killcredit2",
			"modelid1"				=> "male_displayid",
			"modelid2"				=> "female_displayid",
			"modelid3"				=> "male_displayid2",
			"modelid4"				=> "female_displayid2",
			"Health_Mod"				=> "healthmodifier",
			"Mana_Mod"				=> "powermodifier",
			"racialleader"						=> "racialleader",
			"questitem1"					=> "questitem1",
			"questitem2"					=> "questitem2",
			"questitem3"					=> "questitem3",
			"questitem4"					=> "questitem4",
			"questitem5"					=> "questitem5",
			"questitem6"					=> "questitem6",
			"movementid"					=> "movementid"
		),
		"BOGW"	=> array(
			"BOGW"						=> "gameobject_names",
			"Type"						=> "Type",
			"DisplayID"					=> "DisplayID",
			"Name"						=> "Name",
			"Category"					=> "Category",
			"CastBarText"				=> "CastBarText",
			"UnkStr"					=> "UnkStr",
			"spellfocus"				=> "spellfocus",
			"sound1"					=> "sound1",
			"sound2"					=> "sound2",
			"sound3"					=> "sound3",
			"sound4"					=> "sound4",
			"sound5"					=> "sound5",
			"sound6"					=> "sound6",
			"sound7"					=> "sound7",
			"sound8"					=> "sound8",
			"sound9"					=> "sound9",
			"unknown1"					=> "unknown1",
			"unknown2"					=> "unknown2",
			"unknown3"					=> "unknown3",
			"unknown4"					=> "unknown4",
			"unknown5"					=> "unknown5",
			"unknown6"					=> "unknown6",
			"unknown7"					=> "unknown7",
			"unknown8"					=> "unknown8",
			"unknown9"					=> "unknown9",
			"unknown10"					=> "unknown10",
			"unknown11"					=> "unknown11",
			"unknown12"					=> "unknown12",
			"unknown13"					=> "unknown13",
			"unknown14"					=> "unknown14",
			"Size"						=> "Size",
			"QuestItem1"				=> "QuestItem1",
			"QuestItem2"				=> "QuestItem2",
			"QuestItem3"				=> "QuestItem3",
			"QuestItem4"				=> "QuestItem4",
			"QuestItem5"				=> "QuestItem5",
			"QuestItem6"				=> "QuestItem6",
		)
	);
?>